EDA Report

Brought to you by YData

Dataset statistics

Number of variables	19
Number of observations	544025
Missing cells	4665849
Missing cells (%)	45.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	187.8 MiB
Average record size in memory	362.0 B

Variable types

Categorical	2
Numeric	13
DateTime	3
Text	1

Alerts

`month` has constant value "1.0"	Constant
`Stunde des Tages (Ortszeit)` is highly overall correlated with `hour_local`	High correlation
`hour_local` is highly overall correlated with `Stunde des Tages (Ortszeit)`	High correlation
`qkfz` is highly overall correlated with `qlkw` and 1 other fields	High correlation
`qlkw` is highly overall correlated with `qkfz`	High correlation
`qpkw` is highly overall correlated with `qkfz`	High correlation
`vkfz` is highly overall correlated with `vlkw` and 1 other fields	High correlation
`vlkw` is highly overall correlated with `vkfz` and 1 other fields	High correlation
`vpkw` is highly overall correlated with `vkfz` and 1 other fields	High correlation
`Vollständigkeit` has 354712 (65.2%) missing values	Missing
`ZScore_Det0` has 358781 (65.9%) missing values	Missing
`ZScore_Det1` has 356734 (65.6%) missing values	Missing
`ZScore_Det2` has 356655 (65.6%) missing values	Missing
`hist_cor` has 355832 (65.4%) missing values	Missing
`localTime` has 354712 (65.2%) missing values	Missing
`month` has 354712 (65.2%) missing values	Missing
`qkfz` has 354712 (65.2%) missing values	Missing
`qlkw` has 354712 (65.2%) missing values	Missing
`qpkw` has 354712 (65.2%) missing values	Missing
`vkfz` has 359496 (66.1%) missing values	Missing
`vlkw` has 389818 (71.7%) missing values	Missing
`vpkw` has 360261 (66.2%) missing values	Missing
`Stunde des Tages (Ortszeit)` has 22614 (4.2%) zeros	Zeros
`ZScore_Det0` has 80140 (14.7%) zeros	Zeros
`ZScore_Det1` has 81256 (14.9%) zeros	Zeros
`ZScore_Det2` has 156995 (28.9%) zeros	Zeros
`qlkw` has 35106 (6.5%) zeros	Zeros
`qpkw` has 5549 (1.0%) zeros	Zeros
`hour_local` has 22614 (4.2%) zeros	Zeros

Reproduction

Analysis started	2025-11-19 10:08:32.876908
Analysis finished	2025-11-19 10:09:41.489241
Duration	1 minute and 8.61 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

Datum (Ortszeit)
Categorical

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.6 MiB

2024-01-26	17981
2024-01-20	17857
2024-01-15	17830
2024-01-31	17819
2024-01-21	17805
Other values (26)	454733

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	5440250
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2024-01-01
2nd row	2024-01-01
3rd row	2024-01-01
4th row	2024-01-01
5th row	2024-01-01

Common Values

Value	Count	Frequency (%)
2024-01-26	17981	3.3%
2024-01-20	17857	3.3%
2024-01-15	17830	3.3%
2024-01-31	17819	3.3%
2024-01-21	17805	3.3%
2024-01-22	17785	3.3%
2024-01-02	17756	3.3%
2024-01-18	17737	3.3%
2024-01-24	17726	3.3%
2024-01-30	17722	3.3%
Other values (21)	366007	67.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2024-01-26	17981	3.3%
2024-01-20	17857	3.3%
2024-01-15	17830	3.3%
2024-01-31	17819	3.3%
2024-01-21	17805	3.3%
2024-01-22	17785	3.3%
2024-01-02	17756	3.3%
2024-01-18	17737	3.3%
2024-01-24	17726	3.3%
2024-01-30	17722	3.3%
Other values (21)	366007	67.3%

Most occurring characters

Value	Count	Frequency (%)
2	1318085	24.2%
0	1297351	23.8%
-	1088050	20.0%
1	790291	14.5%
4	596721	11.0%
3	88515	1.6%
5	52683	1.0%
9	52551	1.0%
6	52401	1.0%
8	52132	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5440250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	1318085	24.2%
0	1297351	23.8%
-	1088050	20.0%
1	790291	14.5%
4	596721	11.0%
3	88515	1.6%
5	52683	1.0%
9	52551	1.0%
6	52401	1.0%
8	52132	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5440250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	1318085	24.2%
0	1297351	23.8%
-	1088050	20.0%
1	790291	14.5%
4	596721	11.0%
3	88515	1.6%
5	52683	1.0%
9	52551	1.0%
6	52401	1.0%
8	52132	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5440250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	1318085	24.2%
0	1297351	23.8%
-	1088050	20.0%
1	790291	14.5%
4	596721	11.0%
3	88515	1.6%
5	52683	1.0%
9	52551	1.0%
6	52401	1.0%
8	52132	1.0%

Stunde des Tages (Ortszeit)
Real number (ℝ)

High correlation Zeros

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.388157

Minimum	0
Maximum	23
Zeros	22614
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	17
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.8450125
Coefficient of variation (CV)	0.60106412
Kurtosis	-1.1977
Mean	11.388157
Median Absolute Deviation (MAD)	6
Skewness	-6.2380842 × 10^-5
Sum	6195442
Variance	46.854196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
16	23217	4.3%
12	23213	4.3%
8	23005	4.2%
15	22967	4.2%
11	22965	4.2%
13	22953	4.2%
20	22951	4.2%
18	22951	4.2%
17	22949	4.2%
21	22947	4.2%
Other values (14)	313907	57.7%

Value	Count	Frequency (%)
0	22614	4.2%
1	22873	4.2%
2	22874	4.2%
3	22855	4.2%
4	22855	4.2%
5	22853	4.2%
6	22832	4.2%
7	22800	4.2%
8	23005	4.2%
9	22842	4.2%

Value	Count	Frequency (%)
23	16778	3.1%
22	22931	4.2%
21	22947	4.2%
20	22951	4.2%
19	22946	4.2%
18	22951	4.2%
17	22949	4.2%
16	23217	4.3%
15	22967	4.2%
14	22944	4.2%

Vollständigkeit
Real number (ℝ)

Missing

Distinct	13
Distinct (%)	< 0.1%
Missing	354712
Missing (%)	65.2%
Infinite	0
Infinite (%)	0.0%
Mean	96.550998

Minimum	8
Maximum	108
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	8
5-th percentile	75
Q1	100
median	100
Q3	100
95-th percentile	100
Maximum	108
Range	100
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.717356
Coefficient of variation (CV)	0.12135924
Kurtosis	29.076948
Mean	96.550998
Median Absolute Deviation (MAD)	0
Skewness	-5.0505301
Sum	18278359
Variance	137.29643
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	159876	29.4%
92	13948	2.6%
83	5692	1.0%
75	3753	0.7%
67	1703	0.3%
8	947	0.2%
58	826	0.2%
17	609	0.1%
25	514	0.1%
42	485	0.1%
Other values (3)	960	0.2%
(Missing)	354712	65.2%

Value	Count	Frequency (%)
8	947	0.2%
17	609	0.1%
25	514	0.1%
33	470	0.1%
42	485	0.1%
50	482	0.1%
58	826	0.2%
67	1703	0.3%
75	3753	0.7%
83	5692	1.0%

Value	Count	Frequency (%)
108	8	< 0.1%
100	159876	29.4%
92	13948	2.6%
83	5692	1.0%
75	3753	0.7%
67	1703	0.3%
58	826	0.2%
50	482	0.1%
42	485	0.1%
33	470	0.1%

ZScore_Det0
Real number (ℝ)

Missing Zeros

Distinct	570
Distinct (%)	0.3%
Missing	358781
Missing (%)	65.9%
Infinite	0
Infinite (%)	0.0%
Mean	-0.1939909

Minimum	-34.87
Maximum	4.21
Zeros	80140
Zeros (%)	14.7%
Negative	51518
Negative (%)	9.5%
Memory size	4.2 MiB

Quantile statistics

Minimum	-34.87
5-th percentile	-2.42
Q1	-0.15
median	0
Q3	0.18
95-th percentile	0.88
Maximum	4.21
Range	39.08
Interquartile range (IQR)	0.33

Descriptive statistics

Standard deviation	0.92482634
Coefficient of variation (CV)	-4.7673697
Kurtosis	16.286641
Mean	-0.1939909
Median Absolute Deviation (MAD)	0.17
Skewness	-2.043455
Sum	-35935.65
Variance	0.85530375
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80140	14.7%
-1.38	1050	0.2%
-1.31	902	0.2%
0.48	875	0.2%
0.58	866	0.2%
0.49	823	0.2%
0.42	791	0.1%
0.39	775	0.1%
-1.41	767	0.1%
0.46	743	0.1%
Other values (560)	97512	17.9%
(Missing)	358781	65.9%

Value	Count	Frequency (%)
-34.87	1	< 0.1%
-15.54	1	< 0.1%
-11.15	2	< 0.1%
-10.86	1	< 0.1%
-9.84	1	< 0.1%
-9.76	4	< 0.1%
-9.32	3	< 0.1%
-8.08	2	< 0.1%
-7.59	24	< 0.1%
-7.41	5	< 0.1%

Value	Count	Frequency (%)
4.21	24	< 0.1%
3.97	24	< 0.1%
3.62	9	< 0.1%
3.45	1	< 0.1%
3.1	24	< 0.1%
2.48	24	< 0.1%
2.31	24	< 0.1%
2.26	24	< 0.1%
2.24	8	< 0.1%
2.17	24	< 0.1%

ZScore_Det1
Real number (ℝ)

Missing Zeros

Distinct	566
Distinct (%)	0.3%
Missing	356734
Missing (%)	65.6%
Infinite	0
Infinite (%)	0.0%
Mean	-0.20558329

Minimum	-34.87
Maximum	4.34
Zeros	81256
Zeros (%)	14.9%
Negative	51865
Negative (%)	9.5%
Memory size	4.2 MiB

Quantile statistics

Minimum	-34.87
5-th percentile	-2.38
Q1	-0.14
median	0
Q3	0.17
95-th percentile	0.85
Maximum	4.34
Range	39.21
Interquartile range (IQR)	0.31

Descriptive statistics

Standard deviation	0.92613423
Coefficient of variation (CV)	-4.50491
Kurtosis	16.970601
Mean	-0.20558329
Median Absolute Deviation (MAD)	0.16
Skewness	-2.1330175
Sum	-38503.9
Variance	0.85772461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81256	14.9%
-1.43	1168	0.2%
-1.27	1058	0.2%
0.48	902	0.2%
0.44	825	0.2%
0.3	802	0.1%
0.39	787	0.1%
0.42	766	0.1%
0.66	765	0.1%
0.47	765	0.1%
Other values (556)	98197	18.1%
(Missing)	356734	65.6%

Value	Count	Frequency (%)
-34.87	1	< 0.1%
-15.54	1	< 0.1%
-15.41	1	< 0.1%
-11.95	5	< 0.1%
-11.15	2	< 0.1%
-9.84	1	< 0.1%
-9.76	4	< 0.1%
-9.31	3	< 0.1%
-8.08	2	< 0.1%
-7.58	24	< 0.1%

Value	Count	Frequency (%)
4.34	24	< 0.1%
3.41	24	< 0.1%
3.3	9	< 0.1%
3.06	8	< 0.1%
2.97	24	< 0.1%
2.73	24	< 0.1%
2.53	24	< 0.1%
2.39	24	< 0.1%
2.32	24	< 0.1%
2.05	24	< 0.1%

ZScore_Det2
Real number (ℝ)

Missing Zeros

Distinct	414
Distinct (%)	0.2%
Missing	356655
Missing (%)	65.6%
Infinite	0
Infinite (%)	0.0%
Mean	-0.03569691

Minimum	-15.41
Maximum	4.12
Zeros	156995
Zeros (%)	28.9%
Negative	13232
Negative (%)	2.4%
Memory size	4.2 MiB

Quantile statistics

Minimum	-15.41
5-th percentile	-0.5
Q1	0
median	0
Q3	0
95-th percentile	0.5
Maximum	4.12
Range	19.53
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.49643542
Coefficient of variation (CV)	-13.906958
Kurtosis	41.397772
Mean	-0.03569691
Median Absolute Deviation (MAD)	0
Skewness	-4.1261846
Sum	-6688.53
Variance	0.24644813
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	156995	28.9%
0.55	330	0.1%
0.52	311	0.1%
0.38	310	0.1%
0.58	309	0.1%
0.47	287	0.1%
0.59	275	0.1%
0.5	264	< 0.1%
0.4	264	< 0.1%
0.8	263	< 0.1%
Other values (404)	27762	5.1%
(Missing)	356655	65.6%

Value	Count	Frequency (%)
-15.41	1	< 0.1%
-11.95	5	< 0.1%
-6.99	5	< 0.1%
-6.8	8	< 0.1%
-6.11	24	< 0.1%
-6.1	4	< 0.1%
-6.03	14	< 0.1%
-5.95	3	< 0.1%
-5.68	3	< 0.1%
-5.51	1	< 0.1%

Value	Count	Frequency (%)
4.12	24	< 0.1%
3.45	1	< 0.1%
3.19	24	< 0.1%
3.09	23	< 0.1%
3.05	8	< 0.1%
2.77	24	< 0.1%
2.36	24	< 0.1%
2.24	8	< 0.1%
2.15	24	< 0.1%
2.04	24	< 0.1%

hist_cor
Real number (ℝ)

Missing

Distinct	164
Distinct (%)	0.1%
Missing	355832
Missing (%)	65.4%
Infinite	0
Infinite (%)	0.0%
Mean	0.77237607

Minimum	-1
Maximum	1
Zeros	214
Zeros (%)	< 0.1%
Negative	4597
Negative (%)	0.8%
Memory size	4.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	0.18
Q1	0.76
median	0.86
Q3	0.91
95-th percentile	0.94
Maximum	1
Range	2
Interquartile range (IQR)	0.15

Descriptive statistics

Standard deviation	0.243079
Coefficient of variation (CV)	0.31471586
Kurtosis	6.9606126
Mean	0.77237607
Median Absolute Deviation (MAD)	0.06
Skewness	-2.5441274
Sum	145355.77
Variance	0.059087402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.91	13717	2.5%
0.9	12577	2.3%
0.92	11624	2.1%
0.93	10904	2.0%
0.89	10861	2.0%
0.87	9283	1.7%
0.94	9047	1.7%
0.88	9033	1.7%
0.86	7940	1.5%
0.85	5842	1.1%
Other values (154)	87365	16.1%
(Missing)	355832	65.4%

Value	Count	Frequency (%)
-1	3	< 0.1%
-0.98	2	< 0.1%
-0.97	2	< 0.1%
-0.84	1	< 0.1%
-0.83	1	< 0.1%
-0.8	24	< 0.1%
-0.76	24	< 0.1%
-0.69	25	< 0.1%
-0.67	9	< 0.1%
-0.64	23	< 0.1%

Value	Count	Frequency (%)
1	3	< 0.1%
0.98	1	< 0.1%
0.97	123	< 0.1%
0.96	1527	0.3%
0.95	5330	1.0%
0.94	9047	1.7%
0.93	10904	2.0%
0.92	11624	2.1%
0.91	13717	2.5%
0.9	12577	2.3%

localTime
Date

Missing

Distinct	743
Distinct (%)	0.4%
Missing	354712
Missing (%)	65.2%
Memory size	4.2 MiB

Minimum	2024-01-01 01:00:00+01:00
Maximum	2024-01-31 23:00:00+01:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

month
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	354712
Missing (%)	65.2%
Memory size	28.3 MiB

1.0	189313

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	567939
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	189313	34.8%
(Missing)	354712	65.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	189313	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	189313	33.3%
.	189313	33.3%
0	189313	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	567939	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	189313	33.3%
.	189313	33.3%
0	189313	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	567939	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	189313	33.3%
.	189313	33.3%
0	189313	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	567939	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	189313	33.3%
.	189313	33.3%
0	189313	33.3%

qkfz
Real number (ℝ)

High correlation Missing

Distinct	1281
Distinct (%)	0.7%
Missing	354712
Missing (%)	65.2%
Infinite	0
Infinite (%)	0.0%
Mean	235.54997

Minimum	0
Maximum	3708
Zeros	4784
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	60
median	187
Q3	367
95-th percentile	618
Maximum	3708
Range	3708
Interquartile range (IQR)	307

Descriptive statistics

Standard deviation	205.49165
Coefficient of variation (CV)	0.87239087
Kurtosis	1.7295734
Mean	235.54997
Median Absolute Deviation (MAD)	142
Skewness	1.0820297
Sum	44592672
Variance	42226.817
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4784	0.9%
1	987	0.2%
24	918	0.2%
22	854	0.2%
4	840	0.2%
12	824	0.2%
7	824	0.2%
20	815	0.1%
8	815	0.1%
2	811	0.1%
Other values (1271)	176841	32.5%
(Missing)	354712	65.2%

Value	Count	Frequency (%)
0	4784	0.9%
1	987	0.2%
2	811	0.1%
3	758	0.1%
4	840	0.2%
5	781	0.1%
6	747	0.1%
7	824	0.2%
8	815	0.1%
9	768	0.1%

Value	Count	Frequency (%)
3708	1	< 0.1%
2368	1	< 0.1%
2277	1	< 0.1%
2081	1	< 0.1%
1925	1	< 0.1%
1840	1	< 0.1%
1816	1	< 0.1%
1807	1	< 0.1%
1774	1	< 0.1%
1753	1	< 0.1%

qlkw
Real number (ℝ)

High correlation Missing Zeros

Distinct	605
Distinct (%)	0.3%
Missing	354712
Missing (%)	65.2%
Infinite	0
Infinite (%)	0.0%
Mean	16.895559

Minimum	0
Maximum	1356
Zeros	35106
Zeros (%)	6.5%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	13
95-th percentile	64
Maximum	1356
Range	1356
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	45.577299
Coefficient of variation (CV)	2.6975904
Kurtosis	59.695335
Mean	16.895559
Median Absolute Deviation (MAD)	5
Skewness	6.6284161
Sum	3198549
Variance	2077.2902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35106	6.5%
1	18060	3.3%
2	15345	2.8%
3	12818	2.4%
4	10843	2.0%
5	9103	1.7%
6	7463	1.4%
7	7066	1.3%
8	6112	1.1%
9	5147	0.9%
Other values (595)	62250	11.4%
(Missing)	354712	65.2%

Value	Count	Frequency (%)
0	35106	6.5%
1	18060	3.3%
2	15345	2.8%
3	12818	2.4%
4	10843	2.0%
5	9103	1.7%
6	7463	1.4%
7	7066	1.3%
8	6112	1.1%
9	5147	0.9%

Value	Count	Frequency (%)
1356	1	< 0.1%
945	1	< 0.1%
898	1	< 0.1%
884	1	< 0.1%
865	1	< 0.1%
862	1	< 0.1%
794	1	< 0.1%
789	1	< 0.1%
788	1	< 0.1%
780	1	< 0.1%

qpkw
Real number (ℝ)

High correlation Missing Zeros

Distinct	1230
Distinct (%)	0.6%
Missing	354712
Missing (%)	65.2%
Infinite	0
Infinite (%)	0.0%
Mean	218.64994

Minimum	0
Maximum	2352
Zeros	5549
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	51
median	168
Q3	344
95-th percentile	588
Maximum	2352
Range	2352
Interquartile range (IQR)	293

Descriptive statistics

Standard deviation	196.79911
Coefficient of variation (CV)	0.90006477
Kurtosis	1.3317524
Mean	218.64994
Median Absolute Deviation (MAD)	133
Skewness	1.0918288
Sum	41393276
Variance	38729.888
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5549	1.0%
1	1353	0.2%
2	1118	0.2%
12	1038	0.2%
4	1030	0.2%
5	992	0.2%
3	987	0.2%
14	970	0.2%
8	958	0.2%
16	945	0.2%
Other values (1220)	174373	32.1%
(Missing)	354712	65.2%

Value	Count	Frequency (%)
0	5549	1.0%
1	1353	0.2%
2	1118	0.2%
3	987	0.2%
4	1030	0.2%
5	992	0.2%
6	875	0.2%
7	922	0.2%
8	958	0.2%
9	896	0.2%

Value	Count	Frequency (%)
2352	1	< 0.1%
1924	1	< 0.1%
1824	1	< 0.1%
1799	1	< 0.1%
1774	1	< 0.1%
1741	1	< 0.1%
1731	1	< 0.1%
1690	1	< 0.1%
1676	1	< 0.1%
1655	1	< 0.1%

utc
Date

Distinct	744
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Minimum	2023-12-31 23:00:00+00:00
Maximum	2024-01-31 22:00:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

vkfz
Real number (ℝ)

High correlation Missing

Distinct	101
Distinct (%)	0.1%
Missing	359496
Missing (%)	66.1%
Infinite	0
Infinite (%)	0.0%
Mean	45.406456

Minimum	-1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	42
Negative (%)	< 0.1%
Memory size	4.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	24
Q1	39
median	46
Q3	52
95-th percentile	62
Maximum	100
Range	101
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	12.674587
Coefficient of variation (CV)	0.27913622
Kurtosis	2.8452344
Mean	45.406456
Median Absolute Deviation (MAD)	6
Skewness	-0.32737034
Sum	8378808
Variance	160.64515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	8055	1.5%
47	8032	1.5%
46	7997	1.5%
49	7806	1.4%
45	7553	1.4%
50	7546	1.4%
44	7450	1.4%
51	6956	1.3%
43	6914	1.3%
52	6645	1.2%
Other values (91)	109575	20.1%
(Missing)	359496	66.1%

Value	Count	Frequency (%)
-1	42	< 0.1%
1	55	< 0.1%
2	2	< 0.1%
3	2819	0.5%
4	206	< 0.1%
5	157	< 0.1%
6	119	< 0.1%
7	126	< 0.1%
8	125	< 0.1%
9	153	< 0.1%

Value	Count	Frequency (%)
100	86	< 0.1%
99	125	< 0.1%
98	40	< 0.1%
97	46	< 0.1%
96	84	< 0.1%
95	97	< 0.1%
94	106	< 0.1%
93	139	< 0.1%
92	154	< 0.1%
91	246	< 0.1%

vlkw
Real number (ℝ)

High correlation Missing

Distinct	100
Distinct (%)	0.1%
Missing	389818
Missing (%)	71.7%
Infinite	0
Infinite (%)	0.0%
Mean	46.187618

Minimum	-1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	39
Negative (%)	< 0.1%
Memory size	4.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	28
Q1	40
median	46
Q3	52
95-th percentile	64
Maximum	100
Range	101
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	11.954207
Coefficient of variation (CV)	0.25881845
Kurtosis	2.7901961
Mean	46.187618
Median Absolute Deviation (MAD)	6
Skewness	0.31688122
Sum	7122454
Variance	142.90308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	7240	1.3%
46	7117	1.3%
44	6842	1.3%
50	6469	1.2%
47	6144	1.1%
42	6054	1.1%
49	5846	1.1%
45	5828	1.1%
52	5825	1.1%
43	5510	1.0%
Other values (90)	91332	16.8%
(Missing)	389818	71.7%

Value	Count	Frequency (%)
-1	39	< 0.1%
1	49	< 0.1%
3	744	0.1%
4	31	< 0.1%
5	17	< 0.1%
6	33	< 0.1%
7	37	< 0.1%
8	43	< 0.1%
9	73	< 0.1%
10	64	< 0.1%

Value	Count	Frequency (%)
100	85	< 0.1%
99	117	< 0.1%
98	38	< 0.1%
97	35	< 0.1%
96	73	< 0.1%
95	98	< 0.1%
94	109	< 0.1%
93	134	< 0.1%
92	188	< 0.1%
91	269	< 0.1%

vpkw
Real number (ℝ)

High correlation Missing

Distinct	101
Distinct (%)	0.1%
Missing	360261
Missing (%)	66.2%
Infinite	0
Infinite (%)	0.0%
Mean	45.306551

Minimum	-1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	8
Negative (%)	< 0.1%
Memory size	4.2 MiB

Quantile statistics

Minimum	-1
5-th percentile	24
Q1	39
median	46
Q3	52
95-th percentile	62
Maximum	100
Range	101
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	12.556392
Coefficient of variation (CV)	0.27714296
Kurtosis	2.6614745
Mean	45.306551
Median Absolute Deviation (MAD)	6
Skewness	-0.40793161
Sum	8325713
Variance	157.66297
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	7998	1.5%
47	7969	1.5%
46	7954	1.5%
49	7754	1.4%
50	7589	1.4%
45	7509	1.4%
44	7467	1.4%
51	6936	1.3%
43	6882	1.3%
52	6635	1.2%
Other values (91)	109071	20.0%
(Missing)	360261	66.2%

Value	Count	Frequency (%)
-1	8	< 0.1%
1	11	< 0.1%
2	2	< 0.1%
3	2789	0.5%
4	230	< 0.1%
5	164	< 0.1%
6	129	< 0.1%
7	137	< 0.1%
8	126	< 0.1%
9	162	< 0.1%

Value	Count	Frequency (%)
100	13	< 0.1%
99	37	< 0.1%
98	42	< 0.1%
97	25	< 0.1%
96	63	< 0.1%
95	92	< 0.1%
94	90	< 0.1%
93	138	< 0.1%
92	195	< 0.1%
91	286	0.1%

detector_id
Text

Distinct	485
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	32.4 MiB

Length

Max length	23
Median length	13
Mean length	13.363255
Min length	13

Characters and Unicode

Total characters	7269945
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TEU00002_Det0
2nd row	TEU00002_Det0
3rd row	TEU00002_Det0
4th row	TEU00002_Det0
5th row	TEU00002_Det0

Value	Count	Frequency (%)
teu00002_det0	1487	0.3%
teu00320_det1	1487	0.3%
teu00424_det0	1487	0.3%
teu00424_det1	1487	0.3%
teu00425_det0	1487	0.3%
teu00211_det1	1487	0.3%
teu00211_det0	1487	0.3%
teu00208_det1	1487	0.3%
teu00208_det0	1487	0.3%
teu00248_det1	1487	0.3%
Other values (475)	529155	97.3%

Most occurring characters

Value	Count	Frequency (%)
0	1647620	22.7%
D	583549	8.0%
e	544025	7.5%
t	544025	7.5%
T	524263	7.2%
U	524263	7.2%
_	524263	7.2%
E	524263	7.2%
1	459065	6.3%
2	271463	3.7%
Other values (13)	1123146	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7269945	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1647620	22.7%
D	583549	8.0%
e	544025	7.5%
t	544025	7.5%
T	524263	7.2%
U	524263	7.2%
_	524263	7.2%
E	524263	7.2%
1	459065	6.3%
2	271463	3.7%
Other values (13)	1123146	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7269945	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1647620	22.7%
D	583549	8.0%
e	544025	7.5%
t	544025	7.5%
T	524263	7.2%
U	524263	7.2%
_	524263	7.2%
E	524263	7.2%
1	459065	6.3%
2	271463	3.7%
Other values (13)	1123146	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7269945	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1647620	22.7%
D	583549	8.0%
e	544025	7.5%
t	544025	7.5%
T	524263	7.2%
U	524263	7.2%
_	524263	7.2%
E	524263	7.2%
1	459065	6.3%
2	271463	3.7%
Other values (13)	1123146	15.4%

date_local
Date

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Minimum	2024-01-01 00:00:00
Maximum	2024-01-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=31)

hour_local
Real number (ℝ)

High correlation Zeros

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.388157

Minimum	0
Maximum	23
Zeros	22614
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	17
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.8450125
Coefficient of variation (CV)	0.60106412
Kurtosis	-1.1977
Mean	11.388157
Median Absolute Deviation (MAD)	6
Skewness	-6.2380842 × 10^-5
Sum	6195442
Variance	46.854196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
16	23217	4.3%
12	23213	4.3%
8	23005	4.2%
15	22967	4.2%
11	22965	4.2%
13	22953	4.2%
20	22951	4.2%
18	22951	4.2%
17	22949	4.2%
21	22947	4.2%
Other values (14)	313907	57.7%

Value	Count	Frequency (%)
0	22614	4.2%
1	22873	4.2%
2	22874	4.2%
3	22855	4.2%
4	22855	4.2%
5	22853	4.2%
6	22832	4.2%
7	22800	4.2%
8	23005	4.2%
9	22842	4.2%

Value	Count	Frequency (%)
23	16778	3.1%
22	22931	4.2%
21	22947	4.2%
20	22951	4.2%
19	22946	4.2%
18	22951	4.2%
17	22949	4.2%
16	23217	4.3%
15	22967	4.2%
14	22944	4.2%

	Datum (Ortszeit)	Stunde des Tages (Ortszeit)	Vollständigkeit	ZScore_Det0	ZScore_Det1	ZScore_Det2	hist_cor	hour_local	qkfz	qlkw	qpkw	vkfz	vlkw	vpkw
Datum (Ortszeit)	1.000	0.000	0.049	0.065	0.069	0.064	0.192	0.000	0.068	0.019	0.061	0.068	0.066	0.068
Stunde des Tages (Ortszeit)	0.000	1.000	-0.000	-0.004	-0.003	-0.002	-0.001	1.000	0.311	0.102	0.307	-0.107	-0.106	-0.106
Vollständigkeit	0.049	-0.000	1.000	0.004	0.007	-0.003	0.128	-0.000	0.068	0.032	0.083	0.012	-0.035	0.017
ZScore_Det0	0.065	-0.004	0.004	1.000	-0.012	0.072	0.157	-0.004	0.056	-0.022	0.068	0.038	0.028	0.039
ZScore_Det1	0.069	-0.003	0.007	-0.012	1.000	0.058	0.158	-0.003	0.059	0.088	0.060	0.056	0.058	0.056
ZScore_Det2	0.064	-0.002	-0.003	0.072	0.058	1.000	0.142	-0.002	0.091	0.052	0.101	0.009	0.007	0.011
hist_cor	0.192	-0.001	0.128	0.157	0.158	0.142	1.000	-0.001	0.393	0.184	0.409	0.296	0.228	0.301
hour_local	0.000	1.000	-0.000	-0.004	-0.003	-0.002	-0.001	1.000	0.311	0.102	0.307	-0.107	-0.106	-0.106
qkfz	0.068	0.311	0.068	0.056	0.059	0.091	0.393	0.311	1.000	0.569	0.975	-0.082	-0.142	-0.082
qlkw	0.019	0.102	0.032	-0.022	0.088	0.052	0.184	0.102	0.569	1.000	0.466	-0.050	-0.089	-0.054
qpkw	0.061	0.307	0.083	0.068	0.060	0.101	0.409	0.307	0.975	0.466	1.000	-0.079	-0.138	-0.077
vkfz	0.068	-0.107	0.012	0.038	0.056	0.009	0.296	-0.107	-0.082	-0.050	-0.079	1.000	0.964	0.997
vlkw	0.066	-0.106	-0.035	0.028	0.058	0.007	0.228	-0.106	-0.142	-0.089	-0.138	0.964	1.000	0.952
vpkw	0.068	-0.106	0.017	0.039	0.056	0.011	0.301	-0.106	-0.082	-0.054	-0.077	0.997	0.952	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Datum (Ortszeit)	Stunde des Tages (Ortszeit)	Vollständigkeit	ZScore_Det0	ZScore_Det1	ZScore_Det2	hist_cor	localTime	month	qkfz	qlkw	qpkw	utc	vkfz	vlkw	vpkw	detector_id	date_local	hour_local
0	2024-01-01	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2023-12-31 23:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	0
1	2024-01-01	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 00:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	1
2	2024-01-01	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 01:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	2
3	2024-01-01	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 02:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	3
4	2024-01-01	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 03:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	4
5	2024-01-01	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 04:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	5
6	2024-01-01	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 05:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	6
7	2024-01-01	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 06:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	7
8	2024-01-01	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 07:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	8
9	2024-01-01	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-01 08:00:00+00:00	NaN	NaN	NaN	TEU00002_Det0	2024-01-01	9

	Datum (Ortszeit)	Stunde des Tages (Ortszeit)	Vollständigkeit	ZScore_Det0	ZScore_Det1	ZScore_Det2	hist_cor	localTime	month	qkfz	qlkw	qpkw	utc	vkfz	vlkw	vpkw	detector_id	date_local	hour_local
544015	2024-01-31	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 12:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	13
544016	2024-01-31	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 13:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	14
544017	2024-01-31	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 14:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	15
544018	2024-01-31	16	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 15:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	16
544019	2024-01-31	17	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 16:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	17
544020	2024-01-31	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 17:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	18
544021	2024-01-31	19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 18:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	19
544022	2024-01-31	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 19:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	20
544023	2024-01-31	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 20:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	21
544024	2024-01-31	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2024-01-31 21:00:00+00:00	NaN	NaN	NaN	teuscalaS00000DD00361D0	2024-01-31	22

Overview

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample